[dbo].[BAEEventGetFunctionRegistrationCount]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetFunctionRegistrationCount

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(64)	64
@productCode	varchar(64)	64

SQL Script

create procedure [dbo].[BAEEventGetFunctionRegistrationCount] @eventCode varchar(64),
     @productCode varchar(64) as
SELECT CONVERT(int, SUM(ol.QUANTITY_ORDERED)) AS 'NumberRegistered'
    FROM Order_Lines AS ol
    WHERE ol.PRODUCT_CODE = @eventCode + '/' + @productCode

GO

Uses

[dbo].[Order_Lines]
dbo